CREATE TABLE [dbo].[Customer]
(
[CustomerId] [int] NOT NULL IDENTITY(1, 1),
[CustomerInfoId] [int] NULL,
[CreatedDate] [datetime] NOT NULL,
[IsDeleted] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [PK_Customer_1] PRIMARY KEY CLUSTERED  ([CustomerId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [FK_Customer_CustomerInfo] FOREIGN KEY ([CustomerInfoId]) REFERENCES [dbo].[CustomerInfo] ([CustomerInfoId])
GO
